Hệ thống quản lý phương tiện trong PHP
1 <?php
2 session_start();
3 $connection= mysqli_connect('localhost','root','','vehiclemanagement');
4
5 $select_query="SELECT * FROM `tripcost`";
6 $result= mysqli_query($connection,$select_query);
7
8 ?>
9
10
11
12 <!DOCTYPE html>
13 <html lang="en">
14 <head>
15 <meta charset="UTF-8">
16 <title>trip Details</title>
17 <link href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css" rel="stylesheet">
18 <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
19 <link rel="stylesheet" href="http://cdn.datatables.net/1.10.2/css/jquery.dataTables.min.css">
20 <link rel="stylesheet" href="sweetalert2/sweetalert2.css">
21 <script src="sweetalert2/sweetalert2.min.js"></script>
22 <script type="text/javascript" src="http://cdn.datatables.net/1.10.2/js/jquery.dataTables.min.js"></script>
23 <script type="text/javascript" src="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
24 <link rel="stylesheet" href="animate.css">
25 <link rel="stylesheet" href="style.css">
26
27 </head>
28 <body>
29 <?php include 'navbar_admin.php'; ?>
30 <br><br>
31 <div class="container">
32 <div class="row">
33
34 <div class="col-md-12">
35 <div class="page-header">
36 <h1 style="text-align: center;">Trip Details</h1>
37
38 </div>
39
40 <table id="myTable" class="table table-bordered animated rubberBand">
41 <thead>
42 <th>Booking Id</th>
43 <th>Total Km</th>
44 <th>Oil Cost</th>
45 <th>Extra Cost</th>
46 <th>Total Cost Cost</th>
47 </thead>
48 <tbody>
49 <?php while($row=mysqli_fetch_assoc($result)){ ?>
50 <tr>
51 <td><?php echo $row['booking_id']; ?></td>
52 <td><?php echo $row['total_km']; ?></td>
53 <td><?php echo $row['oil_cost']; ?></td>
54 <td><?php echo $row['extra_cost']; ?></td>
55 <td><?php echo $row['total_cost']; ?></td>
56 </tr>
57 <?php } ?>
58 </tbody>
59 </table>
60
61
62 </div>
63
64 </div>
65 </div>
66 </body>
67 <script>
68 $(document).ready(function(){
69 $('#myTable').dataTable();
70 });
71 </script>
72 </html>